When you use SAS/ACCESS® Interface to Microsoft SQL Server to update an SQL Server table that contains triggers, the following error is returned:

ERROR: CLI cursor fetch error: [DataDirect][ODBC SQL Server
Driver]Connection is busy with results for another hstmt

This error occurs because an update trigger that is defined in the SQL Server table generates multiple results during the update process.

The SQL Server database only permits one active statement per connection, and an active result (most like a row count) might already exist. As a result, the next fetch to process the next update returns the error message.

As a workaround, you can use the following SQL Server option at the top of the trigger code:

Operating System and Release Information